/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.31.55
 Source Server Type    : MySQL
 Source Server Version : 50741
 Source Host           : 192.168.31.55:3306
 Source Schema         : hwb_site_copy

 Target Server Type    : MySQL
 Target Server Version : 50741
 File Encoding         : 65001

 Date: 08/08/2023 15:27:45
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for feed_data
-- ----------------------------
DROP TABLE IF EXISTS `feed_data`;
CREATE TABLE `feed_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `feed_time` datetime DEFAULT NULL,
  `feed_date` date DEFAULT NULL,
  `feed_capacity` int(11) DEFAULT NULL,
  `user_id` varchar(50) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of feed_data
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for feed_data_all
-- ----------------------------
DROP TABLE IF EXISTS `feed_data_all`;
CREATE TABLE `feed_data_all` (
  `feed_date` date NOT NULL,
  `feed_capacity_all` int(11) NOT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`feed_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of feed_data_all
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for fetus_action
-- ----------------------------
DROP TABLE IF EXISTS `fetus_action`;
CREATE TABLE `fetus_action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action_start_time` datetime NOT NULL,
  `action_end_time` datetime NOT NULL,
  `action_date` date DEFAULT NULL,
  `action_times` int(11) NOT NULL,
  `crate_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_calculate` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of fetus_action
-- ----------------------------
BEGIN;
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (1, '2023-06-29 09:02:00', '2023-06-29 10:10:00', '2023-06-29', 4, '2023-06-30 14:49:15', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (2, '2023-06-29 14:43:00', '2023-06-29 15:43:00', '2023-06-29', 4, '2023-06-30 14:50:24', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (3, '2023-06-29 19:27:00', '2023-06-29 20:30:00', '2023-06-29', 5, '2023-06-30 14:51:23', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (4, '2023-06-30 09:13:00', '2023-06-30 10:13:00', '2023-06-30', 4, '2023-06-30 14:57:13', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (5, '2023-06-30 12:25:00', '2023-06-30 13:25:00', '2023-06-30', 7, '2023-06-30 14:57:50', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (6, '2023-06-30 18:55:00', '2023-06-30 19:55:00', '2023-06-30', 3, '2023-06-30 19:54:41', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (7, '2023-07-01 09:33:00', '2023-07-01 10:36:00', '2023-07-01', 4, '2023-07-07 16:42:13', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (8, '2023-07-01 10:42:00', '2023-07-01 11:42:00', '2023-07-01', 2, '2023-07-07 16:43:05', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (9, '2023-07-01 18:39:00', '2023-07-01 19:40:00', '2023-07-01', 4, '2023-07-07 16:43:24', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (10, '2023-07-02 09:39:00', '2023-07-02 10:54:00', '2023-07-02', 4, '2023-07-07 16:43:49', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (11, '2023-07-02 13:36:00', '2023-07-02 14:52:00', '2023-07-02', 6, '2023-07-07 16:44:11', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (12, '2023-07-02 14:52:00', '2023-07-02 15:54:00', '2023-07-02', 4, '2023-07-07 16:44:32', 0);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (13, '2023-07-02 17:36:00', '2023-07-02 18:58:00', '2023-07-02', 5, '2023-07-07 16:44:50', 0);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (14, '2023-07-02 19:58:00', '2023-07-02 19:59:00', '2023-07-02', 7, '2023-07-07 16:45:11', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (15, '2023-07-04 08:47:00', '2023-07-04 10:23:00', '2023-07-04', 5, '2023-07-07 16:46:04', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (16, '2023-07-04 12:23:00', '2023-07-04 14:17:00', '2023-07-04', 4, '2023-07-07 16:46:27', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (17, '2023-07-04 19:07:00', '2023-07-04 20:07:00', '2023-07-04', 8, '2023-07-07 16:46:49', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (18, '2023-07-03 09:14:00', '2023-07-03 10:25:00', '2023-07-03', 4, '2023-07-07 16:48:24', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (19, '2023-07-03 13:48:00', '2023-07-03 14:51:00', '2023-07-03', 5, '2023-07-07 16:48:41', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (20, '2023-07-03 19:22:00', '2023-07-03 20:22:00', '2023-07-03', 5, '2023-07-07 16:48:56', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (21, '2023-07-05 09:29:00', '2023-07-05 10:49:00', '2023-07-05', 3, '2023-07-07 16:49:42', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (22, '2023-07-05 10:49:00', '2023-07-05 19:49:00', '2023-07-05', 4, '2023-07-07 16:49:57', 0);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (23, '2023-07-05 12:16:00', '2023-07-05 13:16:00', '2023-07-05', 4, '2023-07-07 16:50:18', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (24, '2023-07-05 19:19:00', '2023-07-05 21:07:00', '2023-07-05', 5, '2023-07-07 16:50:41', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (25, '2023-07-06 09:01:00', '2023-07-06 10:01:00', '2023-07-06', 3, '2023-07-07 16:51:16', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (26, '2023-07-06 12:10:00', '2023-07-06 13:35:00', '2023-07-06', 4, '2023-07-07 16:51:32', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (27, '2023-07-06 19:33:00', '2023-07-06 20:33:00', '2023-07-06', 5, '2023-07-07 16:51:51', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (28, '2023-07-07 08:55:00', '2023-07-07 09:55:00', '2023-07-07', 3, '2023-07-07 16:52:17', 1);
INSERT INTO `fetus_action` (`id`, `action_start_time`, `action_end_time`, `action_date`, `action_times`, `crate_time`, `is_calculate`) VALUES (29, '2023-07-07 12:18:00', '2023-07-07 13:25:00', '2023-07-07', 4, '2023-07-07 16:52:48', 1);
COMMIT;

-- ----------------------------
-- Table structure for fetus_action_all
-- ----------------------------
DROP TABLE IF EXISTS `fetus_action_all`;
CREATE TABLE `fetus_action_all` (
  `action_date` date NOT NULL,
  `action_times_all` int(11) DEFAULT NULL,
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`action_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of fetus_action_all
-- ----------------------------
BEGIN;
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-06-29', 39, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-06-30', 42, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-07-01', 30, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-07-02', 51, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-07-03', 42, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-07-04', 51, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-07-05', 36, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-07-06', 36, '2023-07-24 16:10:19', NULL);
INSERT INTO `fetus_action_all` (`action_date`, `action_times_all`, `create_time`, `update_time`) VALUES ('2023-07-07', 21, '2023-07-24 16:10:19', NULL);
COMMIT;

-- ----------------------------
-- Table structure for file_info
-- ----------------------------
DROP TABLE IF EXISTS `file_info`;
CREATE TABLE `file_info` (
  `file_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of file_info
-- ----------------------------
BEGIN;
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('2de7a911-3b5c-4bb5-8bf6-d3f019b18f17', 'P648719637.jpg', 'weibo-imgs/20230806/', '50826c8e-e97e-44fa-a6a4-13ef8e3571d7', '2023-08-06 15:52:13');
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('8e13f110-0ee3-4acf-8367-2c4eb804a80a', 'P948043369.jpg', 'weibo-imgs/20230804/', 'a2ce7ee1-8946-4ec8-a9d1-d91619a07a44', '2023-08-04 20:13:27');
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('adf3fd06-30a6-4bba-9353-b739188a780b', 'P858772354.jpg', 'weibo-imgs/20230808/', '86a76d57-cc00-47af-8a68-d99fd8416b0c', '2023-08-08 15:11:07');
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('ce7d9ff5-af98-40c1-b4af-b97d43fe26b6', 'P686047107.jpg', 'weibo-imgs/20230808/', '86a76d57-cc00-47af-8a68-d99fd8416b0c', '2023-08-08 15:23:16');
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('d2bd1ab6-7c8b-483b-8c83-5972afc6b64c', 'doges.jpeg', 'weibo-imgs/20230808/', '86a76d57-cc00-47af-8a68-d99fd8416b0c', '2023-08-08 15:11:06');
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('d4728aa5-5d4b-48b4-90ed-8993041372cd', 'IMG_8831.jpeg', 'weibo-imgs/20230806/', '50826c8e-e97e-44fa-a6a4-13ef8e3571d7', '2023-08-06 15:52:13');
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('e17e3ce0-e0e1-45b3-8bac-7ec79fc634ca', '1.jpg', 'weibo-imgs/20230808/', '86a76d57-cc00-47af-8a68-d99fd8416b0c', '2023-08-08 15:23:16');
INSERT INTO `file_info` (`file_id`, `file_name`, `file_path`, `user_id`, `create_time`) VALUES ('f44f1611-17cd-4bec-ad94-6f646c7aed23', '3033BEF4-D17F-43F0-A9BA-35012C6E0436.jpeg', 'weibo-imgs/20230804/', 'a2ce7ee1-8946-4ec8-a9d1-d91619a07a44', '2023-08-04 20:13:26');
COMMIT;

-- ----------------------------
-- Table structure for invite_code
-- ----------------------------
DROP TABLE IF EXISTS `invite_code`;
CREATE TABLE `invite_code` (
  `invite_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `is_used` tinyint(1) DEFAULT '0',
  `used_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`invite_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of invite_code
-- ----------------------------
BEGIN;
INSERT INTO `invite_code` (`invite_id`, `create_time`, `is_used`, `used_time`) VALUES ('1234', '2023-08-04 20:10:23', 1, '2023-08-04 20:12:42');
INSERT INTO `invite_code` (`invite_id`, `create_time`, `is_used`, `used_time`) VALUES ('1345', '2023-08-06 15:45:16', 1, '2023-08-06 15:45:29');
INSERT INTO `invite_code` (`invite_id`, `create_time`, `is_used`, `used_time`) VALUES ('ABCD', '2023-08-08 14:55:13', 1, '2023-08-08 14:56:40');
COMMIT;

-- ----------------------------
-- Table structure for m_emoji
-- ----------------------------
DROP TABLE IF EXISTS `m_emoji`;
CREATE TABLE `m_emoji` (
  `emoji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_no` int(11) DEFAULT NULL,
  PRIMARY KEY (`emoji`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of m_emoji
-- ----------------------------
BEGIN;
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128512;', 1);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128513;', 2);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128514;', 3);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128515;', 4);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128516;', 5);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128517;', 6);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128518;', 7);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128519;', 8);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128520;', 9);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128521;', 10);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128522;', 11);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128523;', 12);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128524;', 13);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128525;', 14);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128526;', 15);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128527;', 16);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128528;', 17);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128529;', 18);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128530;', 19);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128531;', 20);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128532;', 21);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128533;', 22);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128534;', 23);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128535;', 24);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128536;', 25);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128537;', 26);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128538;', 27);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128539;', 28);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128540;', 29);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128541;', 30);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128542;', 31);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128543;', 32);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128544;', 33);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128545;', 34);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128546;', 35);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128547;', 36);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128548;', 37);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128549;', 38);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128550;', 39);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128551;', 40);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128552;', 41);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128553;', 42);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128554;', 43);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128555;', 44);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128556;', 45);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128557;', 46);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128558;', 47);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128559;', 48);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128560;', 49);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128561;', 50);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128562;', 51);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128563;', 52);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128564;', 53);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128565;', 54);
INSERT INTO `m_emoji` (`emoji`, `order_no`) VALUES ('&#128566;', 55);
COMMIT;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
  `client_id` varchar(48) NOT NULL,
  `resource_ids` varchar(256) DEFAULT NULL,
  `client_secret` varchar(256) DEFAULT NULL,
  `scope` varchar(256) DEFAULT NULL,
  `authorized_grant_types` varchar(256) DEFAULT NULL,
  `web_server_redirect_uri` varchar(256) DEFAULT NULL,
  `authorities` varchar(256) DEFAULT NULL,
  `access_token_validity` int(11) DEFAULT NULL,
  `refresh_token_validity` int(11) DEFAULT NULL,
  `additional_information` varchar(4096) DEFAULT NULL,
  `autoapprove` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`client_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `oauth_client_details` (`client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `autoapprove`) VALUES ('hwb_site', NULL, '$2a$10$UAj8c/2GO0hRWk/JDtYfhut62TeQip16V7Ky1j6DkJtEjz9V4PoaO', 'all', 'authorization_code,password,refresh_token', NULL, NULL, 3600, 7200, NULL, 'true');
COMMIT;

-- ----------------------------
-- Table structure for permission_info
-- ----------------------------
DROP TABLE IF EXISTS `permission_info`;
CREATE TABLE `permission_info` (
  `permission_id` int(11) NOT NULL,
  `permission_name` varchar(255) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of permission_info
-- ----------------------------
BEGIN;
INSERT INTO `permission_info` (`permission_id`, `permission_name`) VALUES (1, 'fa');
INSERT INTO `permission_info` (`permission_id`, `permission_name`) VALUES (2, 'fd');
INSERT INTO `permission_info` (`permission_id`, `permission_name`) VALUES (3, 'wb');
COMMIT;

-- ----------------------------
-- Table structure for role_info
-- ----------------------------
DROP TABLE IF EXISTS `role_info`;
CREATE TABLE `role_info` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(255) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  `permission_id` int(11) NOT NULL,
  PRIMARY KEY (`role_id`,`permission_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of role_info
-- ----------------------------
BEGIN;
INSERT INTO `role_info` (`role_id`, `role_name`, `permission_id`) VALUES (1, 'user', 3);
INSERT INTO `role_info` (`role_id`, `role_name`, `permission_id`) VALUES (2, 'power_user', 1);
INSERT INTO `role_info` (`role_id`, `role_name`, `permission_id`) VALUES (2, 'power_user', 2);
INSERT INTO `role_info` (`role_id`, `role_name`, `permission_id`) VALUES (2, 'power_user', 3);
COMMIT;

-- ----------------------------
-- Table structure for transactions
-- ----------------------------
DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
  `create_time` datetime DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of transactions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `user_id` varchar(50) COLLATE utf8mb4_german2_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  `nick_name` varchar(255) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  `avatar` varchar(30) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  `is_valid` tinyint(1) DEFAULT '1',
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `roles_id` varchar(255) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  `invite_code` varchar(10) COLLATE utf8mb4_german2_ci DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_german2_ci;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` (`user_id`, `username`, `password`, `nick_name`, `avatar`, `is_valid`, `create_date`, `roles_id`, `invite_code`) VALUES ('2d99692b-5246-46b5-94a7-87424d9fa089', 'hwb1990', '$2a$10$sN42mgMWzu11fqVQ3ZZ7W./z4PaCq5rkruAhNQGIuKEFL8/4oLLey', NULL, NULL, 1, NULL, '1', NULL);
INSERT INTO `user_info` (`user_id`, `username`, `password`, `nick_name`, `avatar`, `is_valid`, `create_date`, `roles_id`, `invite_code`) VALUES ('50826c8e-e97e-44fa-a6a4-13ef8e3571d7', 'hwbbwh', '$2a$10$sN42mgMWzu11fqVQ3ZZ7W./z4PaCq5rkruAhNQGIuKEFL8/4oLLey', '超级大帅哥', NULL, 1, NULL, '2', NULL);
INSERT INTO `user_info` (`user_id`, `username`, `password`, `nick_name`, `avatar`, `is_valid`, `create_date`, `roles_id`, `invite_code`) VALUES ('86a76d57-cc00-47af-8a68-d99fd8416b0c', 'yzr', '$2a$10$dWqqesYlEIDfUl2tFw00iuKayZ1bOJRS7XmqZhkPX/6AsB5VVjRJa', NULL, NULL, 1, '2023-08-08 14:56:40', '1', 'ABCD');
INSERT INTO `user_info` (`user_id`, `username`, `password`, `nick_name`, `avatar`, `is_valid`, `create_date`, `roles_id`, `invite_code`) VALUES ('a2ce7ee1-8946-4ec8-a9d1-d91619a07a44', 'chuwang', '$2a$10$/E11mioQlVQ/AD6LuWCz0.t3d2S6dYQsDaKBb.RlRriWvZ6m8/Eti', '楚王', NULL, 1, '2023-08-06 15:45:29', '2', '1345');
COMMIT;

-- ----------------------------
-- Table structure for wb_file
-- ----------------------------
DROP TABLE IF EXISTS `wb_file`;
CREATE TABLE `wb_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wb_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) DEFAULT '0',
  `order_no` int(11) DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `is_thumbnail` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of wb_file
-- ----------------------------
BEGIN;
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (28, '1a938d1e-1ae9-46b0-83ab-abf2ff1875d6', 'f44f1611-17cd-4bec-ad94-6f646c7aed23', 0, 0, '2023-08-04 20:13:27', NULL, 0);
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (29, '1a938d1e-1ae9-46b0-83ab-abf2ff1875d6', '8e13f110-0ee3-4acf-8367-2c4eb804a80a', 0, 0, '2023-08-04 20:13:27', NULL, 1);
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (30, 'd8185f33-61d7-45cd-bde1-2f4198ad2da1', 'd4728aa5-5d4b-48b4-90ed-8993041372cd', 0, 0, '2023-08-06 15:52:13', NULL, 0);
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (31, 'd8185f33-61d7-45cd-bde1-2f4198ad2da1', '2de7a911-3b5c-4bb5-8bf6-d3f019b18f17', 0, 0, '2023-08-06 15:52:13', NULL, 1);
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (32, '31968504-4ae3-4071-8566-9e6cb7d971ec', 'd2bd1ab6-7c8b-483b-8c83-5972afc6b64c', 0, 0, '2023-08-08 15:11:07', NULL, 0);
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (33, '31968504-4ae3-4071-8566-9e6cb7d971ec', 'adf3fd06-30a6-4bba-9353-b739188a780b', 0, 0, '2023-08-08 15:11:07', NULL, 1);
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (34, 'b599e5cc-550f-474a-97fa-b501d0db891f', 'e17e3ce0-e0e1-45b3-8bac-7ec79fc634ca', 0, 0, '2023-08-08 15:23:16', NULL, 0);
INSERT INTO `wb_file` (`id`, `wb_id`, `file_id`, `is_deleted`, `order_no`, `create_time`, `update_time`, `is_thumbnail`) VALUES (35, 'b599e5cc-550f-474a-97fa-b501d0db891f', 'ce7d9ff5-af98-40c1-b4af-b97d43fe26b6', 0, 0, '2023-08-08 15:23:16', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for wb_info
-- ----------------------------
DROP TABLE IF EXISTS `wb_info`;
CREATE TABLE `wb_info` (
  `id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `wb_content` text COLLATE utf8mb4_unicode_ci,
  `is_deleted` tinyint(1) DEFAULT '0',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of wb_info
-- ----------------------------
BEGIN;
INSERT INTO `wb_info` (`id`, `user_id`, `wb_content`, `is_deleted`, `create_time`, `update_time`) VALUES ('1a938d1e-1ae9-46b0-83ab-abf2ff1875d6', 'a2ce7ee1-8946-4ec8-a9d1-d91619a07a44', '合照嘿嘿', 0, '2023-08-04 20:13:25', NULL);
INSERT INTO `wb_info` (`id`, `user_id`, `wb_content`, `is_deleted`, `create_time`, `update_time`) VALUES ('31968504-4ae3-4071-8566-9e6cb7d971ec', '86a76d57-cc00-47af-8a68-d99fd8416b0c', '分享新鲜事', 0, '2023-08-08 15:11:06', NULL);
INSERT INTO `wb_info` (`id`, `user_id`, `wb_content`, `is_deleted`, `create_time`, `update_time`) VALUES ('38e957e5-e54e-438c-9701-52d69180a4c1', 'a2ce7ee1-8946-4ec8-a9d1-d91619a07a44', '2023年最后一个工作日，耶！', 0, '2023-08-04 20:14:23', NULL);
INSERT INTO `wb_info` (`id`, `user_id`, `wb_content`, `is_deleted`, `create_time`, `update_time`) VALUES ('b599e5cc-550f-474a-97fa-b501d0db891f', '86a76d57-cc00-47af-8a68-d99fd8416b0c', '分享图片', 0, '2023-08-08 15:23:16', NULL);
INSERT INTO `wb_info` (`id`, `user_id`, `wb_content`, `is_deleted`, `create_time`, `update_time`) VALUES ('d8185f33-61d7-45cd-bde1-2f4198ad2da1', '50826c8e-e97e-44fa-a6a4-13ef8e3571d7', '新时泰😄', 0, '2023-08-06 15:52:13', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
